TimeFormat(time [, mask ])


Returns a custom-formatted time value. If no mask is specified, the TimeFormat function returns time value using the hh:mm tt format.

See also CreateTime, Now, and ParseDateTime.

time

Any date/time value or string convertible to a time value.

mask

A set of masking characters determining the format:

• h -- Hours with no leading zero for single-digit hours. (Uses a 12-hour clock.)
• hh -- Hours with a leading zero for single-digit hours. (Uses a 12-hour clock.)
• H -- Hours with no leading zero for single-digit hours. (Uses a 24-hour clock.)
• HH -- Hours with a leading zero for single-digit hours. (Uses a 24-hour clock.)
• m -- Minutes with no leading zero for single-digit minutes
• mm -- Minutes with a leading zero for single-digit minutes
• s -- Seconds with no leading zero for single-digit seconds
• ss -- Seconds with a leading zero for single-digit seconds
• t -- Single-character time marker string, such as A or P
• tt -- Multiple-character time marker string, such as AM or PM